4. OPEN JOB DETAILS
Download the above zip
file ( JOB_REFERRAL_STEP 4.zip)
Using the provided template (OPENJOBDETAILSTEMPLATE_STEP 4.pbix), follow through to recreate the
highlighted visuals below
1a. CREATE CALCULATED COLUMN
DAX Code Used: JobOpenDateDiff= DATEDIFF(JobReferral_VW[JobRefStartDate].[Date],JobReferral_VW[JobRefEndDate].[Date],DAY)
1b. CREATE CALCULATED MEASURE
DAX Code Used: AverageOpenJobReferrals = AVERAGE(JobReferral_VW[JobOpenDateDiff2])
1. AVERAGE OPEN JOB REFERRALS
2. DETAILS OF OPEN JOBS
3. COUNT OF HIRING COMPANIES JOBTAGS
Feel Free to Download the
completed Dashboard (OPENJOBDETAILSCOMPLETED_STEP 4.pbix) from the already
downloaded file (JOB_REFERRAL_STEP 4.zip) 
Read more about the differences between Calculated columns and Calculated Measures: https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/